package com.xywang.dao.bill;

import com.xywang.pojo.Bill;

import java.sql.Connection;
import java.util.List;

public interface BillDao {
    // 获取订单列表
    List<Bill> getBillList(Connection connection, Bill bill, int currentPageNo, int pageSize) throws Exception;
    // 获取订单总条数
    int getBillCount(Connection connection, Bill bill) throws Exception;
    // 添加订单
    int addBill(Connection connection, Bill bill) throws Exception;
    // 删除订单
    int deleteBill(Connection connection, int delId) throws Exception;
    // 用id获取订单
    Bill getBillById(Connection connection, int delId) throws Exception;
    // 修改订单
    int modify(Connection connection, Bill bill) throws Exception;
    // 通过ProviderId获取订单数
    int getBillCountByProviderId(Connection connection, String providerId) throws Exception;
}
